Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	343297
Missing cells	12
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.0 MiB
Average record size in memory	104.0 B

Variable types

Numeric	9
Categorical	4

Alerts

`DATA_AQUISICAO` has a high cardinality: 1956 distinct values	High cardinality
`DIAS_ATIVO` is highly overall correlated with `MESES_ATIVO` and 3 other fields	High correlation
`MESES_ATIVO` is highly overall correlated with `DIAS_ATIVO` and 3 other fields	High correlation
`QT_PC_PAGAS` is highly overall correlated with `DIAS_ATIVO` and 4 other fields	High correlation
`QT_PC_VENCIDAS` is highly overall correlated with `DIAS_ATIVO` and 4 other fields	High correlation
`QT_PC_PAGA_EM_DIA` is highly overall correlated with `QT_PC_PAGAS` and 2 other fields	High correlation
`VALOR_PARCELAS_ATRASO` is highly overall correlated with `DIAS_ATIVO` and 4 other fields	High correlation
`PRAZO_FINANCIAMENTO` is highly overall correlated with `VALOR_TABELA` and 1 other fields	High correlation
`VALOR_TABELA` is highly overall correlated with `PRAZO_FINANCIAMENTO` and 1 other fields	High correlation
`PRODUTO` is highly overall correlated with `PRAZO_FINANCIAMENTO` and 1 other fields	High correlation
`QT_PC_VENCIDAS` has 241626 (70.4%) zeros	Zeros
`QT_PC_PAGA_ATRASO` has 218566 (63.7%) zeros	Zeros
`QT_PC_PAGA_EM_DIA` has 3716 (1.1%) zeros	Zeros
`VALOR_PARCELAS_ATRASO` has 241626 (70.4%) zeros	Zeros

Reproduction

Analysis started	2023-05-10 18:33:43.203677
Analysis finished	2023-05-10 18:35:34.978885
Duration	1 minute and 51.78 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

ID_CLIENTE
Real number (ℝ)

Distinct	342336
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1091769 × 10⁸

Minimum	2906
Maximum	5.7111888 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	2906
5-th percentile	418399.6
Q1	599957
median	1935123
Q3	29910640
95-th percentile	5.7109624 × 10⁸
Maximum	5.7111888 × 10⁸
Range	5.7111597 × 10⁸
Interquartile range (IQR)	29310683

Descriptive statistics

Standard deviation	2.17307 × 10⁸
Coefficient of variation (CV)	1.9591735
Kurtosis	0.7015929
Mean	1.1091769 × 10⁸
Median Absolute Deviation (MAD)	1466538
Skewness	1.6384652
Sum	3.807771 × 10¹³
Variance	4.7222333 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
495783	2	< 0.1%
515146	2	< 0.1%
513827	2	< 0.1%
516007	2	< 0.1%
493418	2	< 0.1%
495820	2	< 0.1%
504634	2	< 0.1%
504368	2	< 0.1%
456650	2	< 0.1%
513596	2	< 0.1%
Other values (342326)	343277	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2906	1	< 0.1%
3358	1	< 0.1%
3392	1	< 0.1%
3411	1	< 0.1%
3453	1	< 0.1%
5730	1	< 0.1%
11921	1	< 0.1%
12539	1	< 0.1%
13124	1	< 0.1%
14352	1	< 0.1%

Value	Count	Frequency (%)
571118875	1	< 0.1%
571118873	1	< 0.1%
571118855	1	< 0.1%
571118854	1	< 0.1%
571118853	1	< 0.1%
571118852	1	< 0.1%
571118850	1	< 0.1%
571118842	1	< 0.1%
571118841	1	< 0.1%
571118839	1	< 0.1%

DATA_AQUISICAO
Categorical

Distinct	1956
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

30/11/2020	1274
31/07/2020	1208
30/09/2019	1203
31/10/2019	1201
02/09/2019	1188
Other values (1951)	337223

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3432970
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	113 ?
Unique (%)	< 0.1%

Sample

1st row	18/06/2021
2nd row	10/04/2018
3rd row	09/10/2020
4th row	25/06/2019
5th row	19/09/2019

Common Values

Value	Count	Frequency (%)
30/11/2020	1274	0.4%
31/07/2020	1208	0.4%
30/09/2019	1203	0.4%
31/10/2019	1201	0.3%
02/09/2019	1188	0.3%
01/03/2021	1113	0.3%
14/03/2018	1091	0.3%
29/10/2019	1013	0.3%
31/03/2021	942	0.3%
03/10/2018	930	0.3%
Other values (1946)	332134	96.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
30/11/2020	1274	0.4%
31/07/2020	1208	0.4%
30/09/2019	1203	0.4%
31/10/2019	1201	0.3%
02/09/2019	1188	0.3%
01/03/2021	1113	0.3%
14/03/2018	1091	0.3%
29/10/2019	1013	0.3%
31/03/2021	942	0.3%
03/10/2018	930	0.3%
Other values (1946)	332134	96.7%

Most occurring characters

Value	Count	Frequency (%)
0	868538	25.3%
/	686594	20.0%
2	680312	19.8%
1	544970	15.9%
9	150507	4.4%
8	135974	4.0%
3	91015	2.7%
5	76495	2.2%
6	74063	2.2%
7	65621	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2746376	80.0%
Other Punctuation	686594	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	868538	31.6%
2	680312	24.8%
1	544970	19.8%
9	150507	5.5%
8	135974	5.0%
3	91015	3.3%
5	76495	2.8%
6	74063	2.7%
7	65621	2.4%
4	58881	2.1%

Other Punctuation

Value	Count	Frequency (%)
/	686594	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3432970	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	868538	25.3%
/	686594	20.0%
2	680312	19.8%
1	544970	15.9%
9	150507	4.4%
8	135974	4.0%
3	91015	2.7%
5	76495	2.2%
6	74063	2.2%
7	65621	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3432970	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	868538	25.3%
/	686594	20.0%
2	680312	19.8%
1	544970	15.9%
9	150507	4.4%
8	135974	4.0%
3	91015	2.7%
5	76495	2.2%
6	74063	2.2%
7	65621	1.9%

DIAS_ATIVO
Real number (ℝ)

Distinct	1050
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	520.94136

Minimum	22
Maximum	1296
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	22
5-th percentile	70
Q1	170
median	405
Q3	841
95-th percentile	1204
Maximum	1296
Range	1274
Interquartile range (IQR)	671

Descriptive statistics

Standard deviation	379.75291
Coefficient of variation (CV)	0.72897439
Kurtosis	-1.1289618
Mean	520.94136
Median Absolute Deviation (MAD)	254
Skewness	0.49550853
Sum	1.788376 × 10⁸
Variance	144212.27
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
161	3346	1.0%
168	3270	1.0%
175	3240	0.9%
169	2858	0.8%
174	2729	0.8%
167	2678	0.8%
162	2605	0.8%
176	2547	0.7%
173	2370	0.7%
153	2347	0.7%
Other values (1040)	315307	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22	673	0.2%
23	536	0.2%
24	1	< 0.1%
25	5	< 0.1%
26	577	0.2%
27	311	0.1%
28	622	0.2%
29	522	0.2%
30	508	0.1%
33	442	0.1%

Value	Count	Frequency (%)
1296	642	0.2%
1295	205	0.1%
1294	363	0.1%
1293	165	< 0.1%
1292	6	< 0.1%
1290	318	0.1%
1289	210	0.1%
1288	243	0.1%
1287	217	0.1%
1286	257	0.1%

MESES_ATIVO
Real number (ℝ)

Distinct	42
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.968756

Minimum	1
Maximum	42
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	13
Q3	27
95-th percentile	39
Maximum	42
Range	41
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	12.449125
Coefficient of variation (CV)	0.73364982
Kurtosis	-1.1287235
Mean	16.968756
Median Absolute Deviation (MAD)	8
Skewness	0.49296737
Sum	5825323
Variance	154.98071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
5	44561	13.0%
6	27025	7.9%
4	12094	3.5%
2	10753	3.1%
1	10155	3.0%
8	9924	2.9%
12	9707	2.8%
3	9217	2.7%
10	8632	2.5%
7	8473	2.5%
Other values (32)	192756	56.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10155	3.0%
2	10753	3.1%
3	9217	2.7%
4	12094	3.5%
5	44561	13.0%
6	27025	7.9%
7	8473	2.5%
8	9924	2.9%
9	8298	2.4%
10	8632	2.5%

Value	Count	Frequency (%)
42	5669	1.7%
41	4271	1.2%
40	6478	1.9%
39	5386	1.6%
38	5524	1.6%
37	5034	1.5%
36	5557	1.6%
35	6452	1.9%
34	6249	1.8%
33	6275	1.8%

PRAZO_FINANCIAMENTO
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

120	184412
60	110786
240	37460
36	10639

Length

Max length	3
Median length	3
Mean length	2.6462975
Min length	2

Characters and Unicode

Total characters	908466
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	120
2nd row	120
3rd row	120
4th row	120
5th row	120

Common Values

Value	Count	Frequency (%)
120	184412	53.7%
60	110786	32.3%
240	37460	10.9%
36	10639	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
120	184412	53.7%
60	110786	32.3%
240	37460	10.9%
36	10639	3.1%

Most occurring characters

Value	Count	Frequency (%)
0	332658	36.6%
2	221872	24.4%
1	184412	20.3%
6	121425	13.4%
4	37460	4.1%
3	10639	1.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	908466	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	332658	36.6%
2	221872	24.4%
1	184412	20.3%
6	121425	13.4%
4	37460	4.1%
3	10639	1.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	908466	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	332658	36.6%
2	221872	24.4%
1	184412	20.3%
6	121425	13.4%
4	37460	4.1%
3	10639	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	908466	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	332658	36.6%
2	221872	24.4%
1	184412	20.3%
6	121425	13.4%
4	37460	4.1%
3	10639	1.2%

VALOR_TABELA
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

80000	245218
300000	48476
20000	42447
230000	7156

Length

Max length	6
Median length	5
Mean length	5.1620521
Min length	5

Characters and Unicode

Total characters	1772117
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20000
2nd row	80000
3rd row	230000
4th row	80000
5th row	80000

Common Values

Value	Count	Frequency (%)
80000	245218	71.4%
300000	48476	14.1%
20000	42447	12.4%
230000	7156	2.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
80000	245218	71.4%
300000	48476	14.1%
20000	42447	12.4%
230000	7156	2.1%

Most occurring characters

Value	Count	Frequency (%)
0	1421664	80.2%
8	245218	13.8%
3	55632	3.1%
2	49603	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1772117	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1421664	80.2%
8	245218	13.8%
3	55632	3.1%
2	49603	2.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	1772117	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1421664	80.2%
8	245218	13.8%
3	55632	3.1%
2	49603	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1772117	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1421664	80.2%
8	245218	13.8%
3	55632	3.1%
2	49603	2.8%

IDADE_CLIENTE
Real number (ℝ)

Distinct	99
Distinct (%)	< 0.1%
Missing	12
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	40.330673

Minimum	0
Maximum	100
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	23
Q1	31
median	39
Q3	48
95-th percentile	63
Maximum	100
Range	100
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	12.511816
Coefficient of variation (CV)	0.31023078
Kurtosis	-0.10701299
Mean	40.330673
Median Absolute Deviation (MAD)	9
Skewness	0.59397818
Sum	13844915
Variance	156.54554
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	11541	3.4%
36	11416	3.3%
34	11328	3.3%
39	11200	3.3%
37	11104	3.2%
35	11049	3.2%
38	11039	3.2%
32	10933	3.2%
31	10724	3.1%
40	10341	3.0%
Other values (89)	232610	67.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	2	< 0.1%
2	4	< 0.1%
3	6	< 0.1%
4	3	< 0.1%
5	7	< 0.1%
6	6	< 0.1%
7	14	< 0.1%
8	14	< 0.1%
9	7	< 0.1%

Value	Count	Frequency (%)
100	1	< 0.1%
99	1	< 0.1%
96	1	< 0.1%
95	3	< 0.1%
94	1	< 0.1%
93	3	< 0.1%
92	6	< 0.1%
91	13	< 0.1%
90	9	< 0.1%
89	10	< 0.1%

PRODUTO
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

AUTOMOVEIS	245218
IMOVEIS	48476
MOTOCICLETAS	42447
CAMINHÕES	7156

Length

Max length	12
Median length	10
Mean length	9.8028238
Min length	7

Characters and Unicode

Total characters	3365280
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MOTOCICLETAS
2nd row	AUTOMOVEIS
3rd row	CAMINHÕES
4th row	AUTOMOVEIS
5th row	AUTOMOVEIS

Common Values

Value	Count	Frequency (%)
AUTOMOVEIS	245218	71.4%
IMOVEIS	48476	14.1%
MOTOCICLETAS	42447	12.4%
CAMINHÕES	7156	2.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
automoveis	245218	71.4%
imoveis	48476	14.1%
motocicletas	42447	12.4%
caminhões	7156	2.1%

Most occurring characters

Value	Count	Frequency (%)
O	623806	18.5%
I	391773	11.6%
M	343297	10.2%
E	343297	10.2%
S	343297	10.2%
T	330112	9.8%
A	294821	8.8%
V	293694	8.7%
U	245218	7.3%
C	92050	2.7%
Other values (4)	63915	1.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3365280	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	623806	18.5%
I	391773	11.6%
M	343297	10.2%
E	343297	10.2%
S	343297	10.2%
T	330112	9.8%
A	294821	8.8%
V	293694	8.7%
U	245218	7.3%
C	92050	2.7%
Other values (4)	63915	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3365280	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	623806	18.5%
I	391773	11.6%
M	343297	10.2%
E	343297	10.2%
S	343297	10.2%
T	330112	9.8%
A	294821	8.8%
V	293694	8.7%
U	245218	7.3%
C	92050	2.7%
Other values (4)	63915	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3358124	99.8%
None	7156	0.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	623806	18.6%
I	391773	11.7%
M	343297	10.2%
E	343297	10.2%
S	343297	10.2%
T	330112	9.8%
A	294821	8.8%
V	293694	8.7%
U	245218	7.3%
C	92050	2.7%
Other values (3)	56759	1.7%

None

Value	Count	Frequency (%)
Õ	7156	100.0%

QT_PC_PAGAS
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0904319

Minimum	0
Maximum	100
Zeros	2956
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	5
Q3	5
95-th percentile	5
Maximum	100
Range	100
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.409509
Coefficient of variation (CV)	0.34458684
Kurtosis	137.26844
Mean	4.0904319
Median Absolute Deviation (MAD)	0
Skewness	1.5708844
Sum	1404233
Variance	1.9867157
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
5	172598	50.3%
4	59290	17.3%
3	43081	12.5%
2	25275	7.4%
1	23582	6.9%
6	16036	4.7%
0	2956	0.9%
7	240	0.1%
8	90	< 0.1%
9	51	< 0.1%
Other values (21)	98	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2956	0.9%
1	23582	6.9%
2	25275	7.4%
3	43081	12.5%
4	59290	17.3%
5	172598	50.3%
6	16036	4.7%
7	240	0.1%
8	90	< 0.1%
9	51	< 0.1%

Value	Count	Frequency (%)
100	1	< 0.1%
80	1	< 0.1%
79	1	< 0.1%
75	1	< 0.1%
50	1	< 0.1%
47	1	< 0.1%
38	1	< 0.1%
34	1	< 0.1%
29	2	< 0.1%
24	1	< 0.1%

QT_PC_VENCIDAS
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7926431

Minimum	0
Maximum	11
Zeros	241626
Zeros (%)	70.4%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	4
Maximum	11
Range	11
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.3372647
Coefficient of variation (CV)	1.6870956
Kurtosis	0.65382557
Mean	0.7926431
Median Absolute Deviation (MAD)	0
Skewness	1.403196
Sum	272112
Variance	1.7882769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	241626	70.4%
3	38096	11.1%
2	30123	8.8%
4	18656	5.4%
1	12931	3.8%
5	1373	0.4%
6	317	0.1%
7	157	< 0.1%
8	9	< 0.1%
9	6	< 0.1%
Other values (2)	3	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	241626	70.4%
1	12931	3.8%
2	30123	8.8%
3	38096	11.1%
4	18656	5.4%
5	1373	0.4%
6	317	0.1%
7	157	< 0.1%
8	9	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
11	1	< 0.1%
10	2	< 0.1%
9	6	< 0.1%
8	9	< 0.1%
7	157	< 0.1%
6	317	0.1%
5	1373	0.4%
4	18656	5.4%
3	38096	11.1%
2	30123	8.8%

QT_PC_PAGA_ATRASO
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5791108

Minimum	0
Maximum	6
Zeros	218566
Zeros (%)	63.7%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.91105301
Coefficient of variation (CV)	1.5731929
Kurtosis	2.3793899
Mean	0.5791108
Median Absolute Deviation (MAD)	0
Skewness	1.6610949
Sum	198807
Variance	0.83001759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	218566	63.7%
1	72422	21.1%
2	34986	10.2%
3	13198	3.8%
4	3833	1.1%
5	265	0.1%
6	27	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	218566	63.7%
1	72422	21.1%
2	34986	10.2%
3	13198	3.8%
4	3833	1.1%
5	265	0.1%
6	27	< 0.1%

Value	Count	Frequency (%)
6	27	< 0.1%
5	265	0.1%
4	3833	1.1%
3	13198	3.8%
2	34986	10.2%
1	72422	21.1%
0	218566	63.7%

QT_PC_PAGA_EM_DIA
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.5113211

Minimum	0
Maximum	100
Zeros	3716
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	4
Q3	5
95-th percentile	5
Maximum	100
Range	100
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.5449813
Coefficient of variation (CV)	0.43999999
Kurtosis	92.820075
Mean	3.5113211
Median Absolute Deviation (MAD)	1
Skewness	1.4939897
Sum	1205426
Variance	2.3869671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
5	107678	31.4%
4	75434	22.0%
3	53447	15.6%
2	46531	13.6%
1	45711	13.3%
6	10340	3.0%
0	3716	1.1%
7	220	0.1%
8	80	< 0.1%
9	46	< 0.1%
Other values (20)	94	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3716	1.1%
1	45711	13.3%
2	46531	13.6%
3	53447	15.6%
4	75434	22.0%
5	107678	31.4%
6	10340	3.0%
7	220	0.1%
8	80	< 0.1%
9	46	< 0.1%

Value	Count	Frequency (%)
100	1	< 0.1%
79	1	< 0.1%
77	1	< 0.1%
74	1	< 0.1%
48	1	< 0.1%
47	1	< 0.1%
38	1	< 0.1%
30	1	< 0.1%
29	1	< 0.1%
25	1	< 0.1%

VALOR_PARCELAS_ATRASO
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	62
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	711.30849

Minimum	0
Maximum	41667
Zeros	241626
Zeros (%)	70.4%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1250
95-th percentile	3750
Maximum	41667
Range	41667
Interquartile range (IQR)	1250

Descriptive statistics

Standard deviation	1435.8407
Coefficient of variation (CV)	2.0185907
Kurtosis	44.290591
Mean	711.30849
Median Absolute Deviation (MAD)	0
Skewness	4.121667
Sum	2.4419007 × 10⁸
Variance	2061638.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	241626	70.4%
2000	24899	7.3%
2667	18436	5.4%
1333	16684	4.9%
667	8668	2.5%
4000	6205	1.8%
2500	5561	1.6%
3750	3182	0.9%
5000	3074	0.9%
5333	2400	0.7%
Other values (52)	12562	3.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	241626	70.4%
167	396	0.1%
333	1878	0.5%
500	735	0.2%
556	110	< 0.1%
667	8668	2.5%
833	29	< 0.1%
1000	1840	0.5%
1111	314	0.1%
1167	3	< 0.1%

Value	Count	Frequency (%)
41667	1	< 0.1%
35000	3	< 0.1%
33333	24	< 0.1%
30000	2	< 0.1%
27500	1	< 0.1%
25000	25	< 0.1%
22500	2	< 0.1%
20000	31	< 0.1%
17500	18	< 0.1%
16667	46	< 0.1%

Auto

Heatmap
Table

	ID_CLIENTE	DIAS_ATIVO	MESES_ATIVO	IDADE_CLIENTE	QT_PC_PAGAS	QT_PC_VENCIDAS	QT_PC_PAGA_ATRASO	QT_PC_PAGA_EM_DIA	VALOR_PARCELAS_ATRASO	PRAZO_FINANCIAMENTO	VALOR_TABELA	PRODUTO
ID_CLIENTE	1.000	-0.301	-0.307	-0.005	-0.070	0.182	0.207	-0.212	0.156	0.238	0.176	0.176
DIAS_ATIVO	-0.301	1.000	0.997	0.034	0.604	-0.751	0.079	0.500	-0.747	0.116	0.064	0.064
MESES_ATIVO	-0.307	0.997	1.000	0.034	0.602	-0.753	0.075	0.500	-0.748	0.119	0.069	0.069
IDADE_CLIENTE	-0.005	0.034	0.034	1.000	0.009	-0.021	-0.006	0.018	-0.015	0.044	0.074	0.074
QT_PC_PAGAS	-0.070	0.604	0.602	0.009	1.000	-0.790	0.117	0.784	-0.776	0.005	0.003	0.003
QT_PC_VENCIDAS	0.182	-0.751	-0.753	-0.021	-0.790	1.000	-0.099	-0.654	0.985	0.104	0.074	0.074
QT_PC_PAGA_ATRASO	0.207	0.079	0.075	-0.006	0.117	-0.099	1.000	-0.460	-0.098	0.081	0.104	0.104
QT_PC_PAGA_EM_DIA	-0.212	0.500	0.500	0.018	0.784	-0.654	-0.460	1.000	-0.637	0.006	0.001	0.001
VALOR_PARCELAS_ATRASO	0.156	-0.747	-0.748	-0.015	-0.776	0.985	-0.098	-0.637	1.000	0.069	0.118	0.118
PRAZO_FINANCIAMENTO	0.238	0.116	0.119	0.044	0.005	0.104	0.081	0.006	0.069	1.000	0.547	0.547
VALOR_TABELA	0.176	0.064	0.069	0.074	0.003	0.074	0.104	0.001	0.118	0.547	1.000	1.000
PRODUTO	0.176	0.064	0.069	0.074	0.003	0.074	0.104	0.001	0.118	0.547	1.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	ID_CLIENTE	DATA_AQUISICAO	DIAS_ATIVO	MESES_ATIVO	PRAZO_FINANCIAMENTO	VALOR_TABELA	IDADE_CLIENTE	PRODUTO	QT_PC_PAGAS	QT_PC_VENCIDAS	QT_PC_PAGA_ATRASO	QT_PC_PAGA_EM_DIA	VALOR_PARCELAS_ATRASO
0	66221	18/06/2021	33	1	120	20000	42.0	MOTOCICLETAS	1	4	0	1	667
1	46982	10/04/2018	1198	39	120	80000	38.0	AUTOMOVEIS	5	0	1	4	0
2	57888	09/10/2020	285	9	120	230000	75.0	CAMINHÕES	5	0	3	2	0
3	51915	25/06/2019	757	25	120	80000	43.0	AUTOMOVEIS	5	0	1	4	0
4	52724	19/09/2019	671	22	120	80000	66.0	AUTOMOVEIS	5	0	5	0	0
5	46665	23/03/2018	1216	40	120	80000	41.0	AUTOMOVEIS	5	0	0	5	0
6	50275	04/02/2019	898	29	240	300000	45.0	IMOVEIS	1	0	0	1	0
7	58359	11/11/2020	252	8	120	80000	47.0	AUTOMOVEIS	5	0	2	3	0
8	48123	31/07/2018	1086	36	120	230000	41.0	CAMINHÕES	4	0	2	2	0
9	65114	03/05/2021	79	2	120	80000	42.0	AUTOMOVEIS	2	3	1	1	2000

	ID_CLIENTE	DATA_AQUISICAO	DIAS_ATIVO	MESES_ATIVO	PRAZO_FINANCIAMENTO	VALOR_TABELA	IDADE_CLIENTE	PRODUTO	QT_PC_PAGAS	QT_PC_VENCIDAS	QT_PC_PAGA_ATRASO	QT_PC_PAGA_EM_DIA	VALOR_PARCELAS_ATRASO
343287	27961680	04/04/2016	171	5	120	80000	49.0	AUTOMOVEIS	3	3	0	3	2000
343288	29574750	10/05/2018	174	5	120	80000	44.0	AUTOMOVEIS	3	3	2	1	2000
343289	571060681	03/11/2020	170	5	120	80000	56.0	AUTOMOVEIS	1	4	0	1	2667
343290	28860520	22/05/2017	162	5	120	80000	49.0	AUTOMOVEIS	3	3	0	3	2000
343291	27173320	28/04/2015	176	6	120	80000	66.0	AUTOMOVEIS	3	3	0	3	2000
343292	29393160	26/01/2018	166	6	120	80000	40.0	AUTOMOVEIS	2	4	0	2	2667
343293	25093062	15/04/2016	176	6	60	80000	46.0	AUTOMOVEIS	2	4	1	1	5333
343294	31101650	30/09/2019	163	6	60	80000	29.0	AUTOMOVEIS	2	3	0	2	4000
343295	26930480	16/01/2015	165	5	120	80000	62.0	AUTOMOVEIS	3	3	0	3	2000
343296	27876161	29/04/2016	154	5	120	80000	25.0	AUTOMOVEIS	3	3	1	2	2000

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

None

Interactions

Correlations

Missing values

Sample